package cn.outsourcing.supermarket.provider;

import org.apache.ibatis.jdbc.SQL;

/**
 * 地址供应器
 *
 * @author gzkemays
 * @since 2021/10/23 16:36
 */
public class RegionProvider {
  public String getAddressByIdGroup() {
    return new SQL() {
      {
        SELECT("*")
            .FROM("hiolabs_region")
            .WHERE("id in (${countryId}, ${cityId}, ${districtId}")
            .ORDER_BY("id asc");
      }
    }.toString();
  }
}
